select x from tablename in sql

Note: copy a table (only copy structure, source table name: a new table name: B)Select * into B from a where 1 <> 1 Description: copy a table (copy data, source table name: A target table name: B)Insert into B (a, B, c) Select D, E, F from B;

SQL statement Import and Export /****** Export to excelExec master.. xp_mongoshell 'bcp settledb. DBO. shanghu out C:/temp1.xls-C-Q-s "gnetdata/gnetdata"-U "sa"-P ""' /*********** Import ExcelSelect *From OpenDataSource ('Microsoft. Jet. oledb.4.0 ',

/****** Export to excelEXEC master.. xp_mongoshell 'bcp SettleDB. dbo. shanghu out c:/temp1.xls-c-q-S "GNETDATA/GNETDATA"-U "sa"-P ""' /*********** Import ExcelSELECT *FROM OpenDataSource ('Microsoft. Jet. OLEDB.4.0 ','Data Source = "c:/test.xls";

ADO Connection Database 1) Get connection string Way one: Remember the connection string connectionstring= "Integrated security=true; Server=. ; Database=dbname " Mode two: In Visual Studio, click "View" À service Explorer, right-click the data

* Description: copy a table (only copy structure, source table name: a new table name: B)Select * into B from a where 1 <> 1 * Description: copy a table (copy data, source table name: A target table name: B)Insert into B (a, B, c) Select D, E, F

Note: copy a table (only copy structure, source table name: a new table name: B)Select * into B from a where 1 <> 1 Description: copy a table (copy data, source table name: a target table name: B)Insert into B (a, B, c) select d, e, f from B;

Note: copy a table (only copy structure, source table name: a new table name: B)Select * into B from a where 1 <> 1 Description: copy a table (copy data, source table name: A target table name: B)Insert into B (a, B, c) Select D, E, F from B;

ADO connection Database 1) obtain the connection string Method 1: Remember the connection string ConnectionString = "Integrated Security = True; server =.; database = DBName" Method 2: in visual studio, click View> service Resource Manager>

Description: Copy table (copy only structure, source table name: A new table name: b)SELECT * into B from a where 1<>1 Description: Copy table (copy data, source table name: A target table name: b)Insert into B (A, B, c) select d,e,f from B;

SQL statement Import and Export /****** Export to excelExec master.. xp_mongoshell 'bcp settledb. DBO. shanghu out C:/temp1.xls-C-Q-s "gnetdata/gnetdata"-U "sa"-P ""' /*********** Import ExcelSelect *From OpenDataSource ('Microsoft. Jet. oledb.4.0 ',